Forum Discussion
Why my OData url don't work ?
Hi
I have an OData feed who work perfectly but not in a particular configuration. I work on Dynamics 365 CRM and can obtain all tables since :
"https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.1/"and contacts Attributes with
https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.0/EntityDefinitions(LogicalName='contact')?$select=LogicalName&$expand=Attributes($select=LogicalName;$filter=AttributeType eq Microsoft.Dynamics.CRM.AttributeTypeCode'Picklist')but not since
https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.0/EntityDefinitions(LogicalName='contact')/Attributes/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet,GlobalOptionSetI've followed all instruction on https://docs.microsoft.com/fr-fr/dynamics365/customer-engagement/developer/webapi/query-metadata-web-api but it don't work.
Someone can say why? I would like to get OptionList attributes but it was not present in table GlobalOptionSetDefinition
The complete code in M in power query :
let
Source = OData.Feed("https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.0/EntityDefinitions(LogicalName='contact')?$select=LogicalName&$expand=Attributes($select=LogicalName;$filter=AttributeType eq Microsoft.Dynamics.CRM.AttributeTypeCode'Picklist')", null, [Implementation="2.0", Headers = [Accept = "application/json"]]),
Attributes = Source[Attributes]
in
AttributesThanks
- Anonymous7 years ago
I've solve this with https://community.powerbi.com/t5/Desktop/Power-Query-How-to-get-a-Dynamics-365-pick-list/td-p/659978
Thanks
4 Replies
- v-frfei-msft
Community Support
Hi Anonymous ,
Hope this case can help you.
https://community.powerbi.com/t5/Power-Query/OData-filter-pass-through/td-p/155386
- AnonymousNot applicable
Not at all :smileyindifferent:
- AnonymousNot applicable
My problem is the access at /Attributes since EntityDefinitions(''contact")
This URL work perfectly
https://proactifrh.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='contact')
but not with /Attributes.
https://proactifrh.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='contact')/Attributes
I don't understand why because it's on official documentation ! And in more, the EntityDefinitions has really a column 'Attributes' !
- AnonymousNot applicable
I've solve this with https://community.powerbi.com/t5/Desktop/Power-Query-How-to-get-a-Dynamics-365-pick-list/td-p/659978
Thanks